1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11
12 namespace SoftQuanLyNhaHang.Models
13 {
14 class BanHangMod
15 {
16 protected int IdBanHang { get; set; }
17 protected string MaSanPham { get; set; }
18 protected string TenSanPham { get; set; }
19 protected double GiaBan { get; set; }
20 protected double ThanhTien { get; set; }
21 protected float SoLuong { get; set; }
22 protected string DonViTinh { get; set; }
23 protected int DonViTinhId { get; set; }
24 protected int KhachHangId { get; set; }
25 protected DateTime NgayMuaHang { get; set; }
26 protected int TrangThai { get; set; }
27 protected int NhapKhoId { get; set; }
28 protected double ChietKhauPhanTram { get; set; }
29 protected double Thue { get; set; }
30
31 protected float SoLuongDaBan { get; set; }
32 protected double GiaNhapTrungBinh { get; set; }
33
34 protected DateTime TuNgay { get; set; }
35 protected int PageSize { get; set; }
36 protected int PageIndex { get; set; }
37
38 public BanHangMod(int _iDBanHang)
39 {
40 IdBanHang = _iDBanHang;
41 }
42 public BanHangMod()
43 { }
44
45 public BanHangMod(string _maSanPham, int _khachHangId)
46 {
47 MaSanPham = _maSanPham;
48 KhachHangId = _khachHangId;
49 }
50
51 public BanHangMod(int _IdBanHang, double _GiaKhuyenMai)
52 {
53 IdBanHang = _IdBanHang;
54 GiaBan = _GiaKhuyenMai;
55 }
56
57 public BanHangMod(string _maSanPham, int _khachHangId, int _trangThai)
58 {
59 MaSanPham = _maSanPham;
60 KhachHangId = _khachHangId;
61 TrangThai = _trangThai;
62 }
63
64 public BanHangMod(string _maSanPham, int _khachHangId, int _trangThai, int _nhapKhoId)
65 {
66 MaSanPham = _maSanPham;
67 KhachHangId = _khachHangId;
68 TrangThai = _trangThai;
69 NhapKhoId = _nhapKhoId;
70 }
71
72 public BanHangMod(string _maSanPham, int _khachHangId, int _trangThai, DateTime _ngayMuaHang)
73 {
74 MaSanPham = _maSanPham;
75 KhachHangId = _khachHangId;
76 TrangThai = _trangThai;
77 NgayMuaHang = _ngayMuaHang;
78 }
79
80 public BanHangMod(int _idBanHang, double _chietKhau, double _thueBh, double _thanhTien)
81 {
82 IdBanHang = _idBanHang;
83 ChietKhauPhanTram = _chietKhau;
84 Thue = _thueBh;
85 ThanhTien = _thanhTien;
86 }
87
88 public BanHangMod(int _idBanHang, string _tenSanPham, double _giaBan, double _thanhTien, float _soLuong)
89 {
90 IdBanHang = _idBanHang;
91 TenSanPham = _tenSanPham;
92 GiaBan = _giaBan;
93 ThanhTien = _thanhTien;
94 SoLuong = _soLuong;
95 }
96
97 public BanHangMod(int _idBanHang, string _tenSanPham, double _giaBan, double _thanhTien, float _soLuong, float _soLuongDaBan)
98 {
99 IdBanHang = _idBanHang;
100 TenSanPham = _tenSanPham;
101 GiaBan = _giaBan;
102 ThanhTien = _thanhTien;
103 SoLuong = _soLuong;
104 SoLuongDaBan = _soLuongDaBan;
105 }
106 /*
107 public BanHangMod(int _idBanHang, string _maSanPham, string _tenSanPham, double _giaBan, double _thanhTien, float _soLuong, string _donViTinh, int _donViTinhId, int _khachHangId, DateTime _ngayMuaHang, int _trangThai, int _nhapKhoId, double _chietKhauPhanTram, double _thue)
108 {
109 IdBanHang = _idBanHang;
110 MaSanPham = _maSanPham;
111 TenSanPham = _tenSanPham;
112 GiaBan = _giaBan;
113 ThanhTien = _thanhTien;
114 SoLuong = _soLuong;
115 DonViTinh = _donViTinh;
116 DonViTinhId = _donViTinhId;
117 KhachHangId = _khachHangId;
118 NgayMuaHang = _ngayMuaHang;
119 TrangThai = _trangThai;
120 NhapKhoId = _nhapKhoId;
121 ChietKhauPhanTram = _chietKhauPhanTram;
122 Thue = _thue;
123 }
124 */
125 public BanHangMod(int _idBanHang, string _maSanPham, string _tenSanPham, double _giaBan, double _thanhTien, float _soLuong, string _donViTinh, int _donViTinhId, int _khachHangId, DateTime _ngayMuaHang, int _trangThai, int _nhapKhoId, double _chietKhauPhanTram, double _thue, float _soLuongDaBan)
126 {
127 IdBanHang = _idBanHang;
128 MaSanPham = _maSanPham;
129 TenSanPham = _tenSanPham;
130 GiaBan = _giaBan;
131 ThanhTien = _thanhTien;
132 SoLuong = _soLuong;
133 DonViTinh = _donViTinh;
134 DonViTinhId = _donViTinhId;
135 KhachHangId = _khachHangId;
136 NgayMuaHang = _ngayMuaHang;
137 TrangThai = _trangThai;
138 NhapKhoId = _nhapKhoId;
139 ChietKhauPhanTram = _chietKhauPhanTram;
140 Thue = _thue;
141 SoLuongDaBan = _soLuongDaBan;
142 }
143
144 public BanHangMod(int _idBanHang, string _maSanPham, string _tenSanPham, double _giaBan, double _thanhTien, float _soLuong, string _donViTinh, int _donViTinhId, int _khachHangId, DateTime _ngayMuaHang, int _trangThai, int _nhapKhoId, double _chietKhauPhanTram, double _thue, int _PageSize, int _PageIndex)
145 {
146 IdBanHang = _idBanHang;
147 MaSanPham = _maSanPham;
148 TenSanPham = _tenSanPham;
149 GiaBan = _giaBan;
150 ThanhTien = _thanhTien;
151 SoLuong = _soLuong;
152 DonViTinh = _donViTinh;
153 DonViTinhId = _donViTinhId;
154 KhachHangId = _khachHangId;
155 NgayMuaHang = _ngayMuaHang;
156 TrangThai = _trangThai;
157 NhapKhoId = _nhapKhoId;
158 ChietKhauPhanTram = _chietKhauPhanTram;
159 Thue = _thue;
160 PageSize = _PageSize;
161 PageIndex = _PageIndex;
162 }
163
164 //tim kiem
165 public BanHangMod(int _idBanHang, string _maSanPham, string _tenSanPham, double _giaBan, double _thanhTien, float _soLuong, string _donViTinh, int _donViTinhId, int _khachHangId, DateTime _ngayMuaHang, int _trangThai, int _nhapKhoId, double _chietKhauPhanTram, double _thue, DateTime _TuNgay, int _PageSize, int _PageIndex)
166 {
167 IdBanHang = _idBanHang;
168 MaSanPham = _maSanPham;
169 TenSanPham = _tenSanPham;
170 GiaBan = _giaBan;
171 ThanhTien = _thanhTien;
172 SoLuong = _soLuong;
173 DonViTinh = _donViTinh;
174 DonViTinhId = _donViTinhId;
175 KhachHangId = _khachHangId;
176 NgayMuaHang = _ngayMuaHang;
177 TrangThai = _trangThai;
178 NhapKhoId = _nhapKhoId;
179 ChietKhauPhanTram = _chietKhauPhanTram;
180 Thue = _thue;
181 TuNgay = _TuNgay;
182 PageSize = _PageSize;
183 PageIndex = _PageIndex;
184 }
185
186 public int InsertBanHang()
187 {
188 int i = 0;
189 string[] paras = new string[15] { "@IdBanHang", "@MaSanPham","@TenSanPham","@GiaBan","@ThanhTien","@SoLuong","@DonViTinh","@DonViTinhId","@KhachHangId","@NgayMuaHang","@TrangThai", "@NhapKhoId", "@ChietKhauPhanTram", "@Thue", "@SoLuongDaBan"};
190 object[] values = new object[15] { IdBanHang, MaSanPham, TenSanPham, GiaBan, ThanhTien, SoLuong, DonViTinh, DonViTinhId, KhachHangId, NgayMuaHang, TrangThai, NhapKhoId, ChietKhauPhanTram, Thue, SoLuongDaBan };
191 i = Int32.Parse(Models.connection.ExcuteScalar("tbl_BanHang_Insert", CommandType.StoredProcedure, paras, values));
192
193 return i;
194 }
195 public int UpdateBanHang()
196 {
197 int i = 0;
198 string[] paras = new string[15] { "@IdBanHang", "@MaSanPham", "@TenSanPham", "@GiaBan", "@ThanhTien", "@SoLuong", "@DonViTinh", "@DonViTinhId", "@KhachHangId", "@NgayMuaHang", "@TrangThai", "@NhapKhoId", "@ChietKhauPhanTram", "@Thue", "@SoLuongDaBan" };
199 object[] values = new object[15] { IdBanHang, MaSanPham, TenSanPham, GiaBan, ThanhTien, SoLuong, DonViTinh, DonViTinhId, KhachHangId, NgayMuaHang, TrangThai, NhapKhoId, ChietKhauPhanTram, Thue, SoLuongDaBan };
200 i = Models.connection.Excute_Sql("tbl_BanHang_Update", CommandType.StoredProcedure, paras, values);
201 return i;
202 }
203
204 public int UpdateBanHang_Thue_ChietKhau()
205 {
206 int i = 0;
207 string[] paras = new string[4] { "@IdBanHang", "@ChietKhauPhanTram", "@Thue", "@ThanhTien" };
208 object[] values = new object[4] { IdBanHang, ChietKhauPhanTram, Thue , ThanhTien};
209 i = Models.connection.Excute_Sql("tbl_BanHang_Update_Thue_ChietKhau", CommandType.StoredProcedure, paras, values);
210 return i;
211 }
212
213
214 //update trang thai
215 public int UpdateBanHang_TrangThai()
216 {
217 int i = 0;
218 string[] paras = new string[3] { "@MaSanPham", "@KhachHangId", "@TrangThai" };
219 object[] values = new object[3] { MaSanPham, KhachHangId, TrangThai };
220 i = Models.connection.Excute_Sql("tbl_BanHang_Update_TrangThai", CommandType.StoredProcedure, paras, values);
221 return i;
222 }
223
224
225
226
227 public int DeleteBanHang()
228 {
229 int i = 0;
230 string[] paras = new string[1] { "@IdBanHang" };
231 object[] values = new object[1] { IdBanHang };
232 i = Models.connection.Excute_Sql("tbl_BanHang_Delete", CommandType.StoredProcedure, paras, values);
233 return i;
234 }
235
236 public DataSet FillDataSet_getBanHangByKhachHangId()
237 {
238 DataSet ds = new DataSet();
239 string[] paras = new string[2] { "@MaSanPham", "@KhachHangId" };
240 object[] values = new object[2] { MaSanPham, KhachHangId };
241 ds = Models.connection.FillDataSet("tbl_BanHang_GetByKhachHangId", CommandType.StoredProcedure, paras, values);
242 return ds;
243 }
244
245 //Tim sản phẩm mua hàng
246 public DataSet FillDataSet_getBanHangByKhachHangId_MuaHang()
247 {
248 DataSet ds = new DataSet();
249 string[] paras = new string[3] { "@MaSanPham", "@KhachHangId", "@TrangThai" };
250 object[] values = new object[3] { MaSanPham, KhachHangId, TrangThai };
251 ds = Models.connection.FillDataSet("tbl_BanHang_GetByKhachHangId_MuaHang", CommandType.StoredProcedure, paras, values);
252 return ds;
253 }
254
255 //lay san pham ban hang da ban
256 public DataSet FillDataSet_getBanHangByKhachHangId_MuaHang2()
257 {
258 DataSet ds = new DataSet();
259 string[] paras = new string[4] { "@MaSanPham", "@KhachHangId", "@TrangThai", "@NhapKhoId" };
260 object[] values = new object[4] { MaSanPham, KhachHangId, TrangThai, NhapKhoId };
261 ds = Models.connection.FillDataSet("tbl_BanHang_GetByKhachHangId_MuaHang2", CommandType.StoredProcedure, paras, values);
262 return ds;
263
264 }
265
266 //update ban hang custom
267 public int Update_BanHang_Update_SL_Gia()
268 {
269 int i = 0;
270 string[] paras = new string[6] { "@IdBanHang", "@TenSanPham", "@GiaBan", "@ThanhTien", "@SoLuong", "@SoLuongDaBan"};
271 object[] values = new object[6] { IdBanHang, TenSanPham, GiaBan, ThanhTien, SoLuong, SoLuongDaBan };
272 i = Models.connection.Excute_Sql("tbl_BanHang_Update_SL_Gia", CommandType.StoredProcedure, paras, values);
273 return i;
274 }
275
276 //update gia khuyen mai
277 public int Update_BanHang_Update_GiaKhuyenMai()
278 {
279 int i = 0;
280 string[] paras = new string[2] { "@IdBanHang","@GiaBan"};
281 object[] values = new object[2] { IdBanHang, GiaBan };
282 i = Models.connection.Excute_Sql("tbl_BanHang_Update_GiaKhuyenMai", CommandType.StoredProcedure, paras, values);
283 return i;
284 }
285
286 //lay danh sach ban hang
287 //lay danh sach khach hang
288 public DataSet FillDataSet_BanHang_BySearch()
289 {
290 DataSet ds = new DataSet();
291 string[] paras = new string[17] { "@IdBanHang", "@MaSanPham", "@TenSanPham", "@GiaBan", "@ThanhTien", "@SoLuong", "@DonViTinh", "@DonViTinhId", "@KhachHangId", "@NgayMuaHang", "@TrangThai", "@NhapKhoId", "@ChietKhauPhanTram", "@Thue","@TuNgay", "@PageSize", "@PageIndex" };
292 object[] values = new object[17] { IdBanHang, MaSanPham, TenSanPham, GiaBan, ThanhTien, SoLuong, DonViTinh, DonViTinhId, KhachHangId, NgayMuaHang, TrangThai, NhapKhoId, ChietKhauPhanTram, Thue ,TuNgay, PageSize, PageIndex};
293 ds = Models.connection.FillDataSet("tbl_BanHang_BySearch", CommandType.StoredProcedure, paras, values);
294 return ds;
295 }
296
297 //tong so mat hang
298 public DataSet FillDataSet_BanHang_CountMatHang_byKhachHangId()
299 {
300 DataSet ds = new DataSet();
301 string[] paras = new string[4] { "@MaSanPham", "@KhachHangId", "@TrangThai", "@NgayMuaHang"};
302 object[] values = new object[4] { MaSanPham, KhachHangId, TrangThai, NgayMuaHang};
303 ds = Models.connection.FillDataSet("tbl_BanHang_CountMatHang_ByKhachHangId", CommandType.StoredProcedure, paras, values);
304 return ds;
305
306 }
307
308
309 }
310 }